How to Update Image in PHP with Demo in MySQL Database

Meta Description: Discover how to update images in PHP and MySQL effortlessly. This tutorial includes a practical demonstration for seamless integration into your web projects.

  Blog   Jul 18, 2024   0   62  Add to Reading List
How to Update Image in PHP with Demo in MySQL Database
PHP
how to update image in php with demo

 How to Update Image in PHP with Demo in MySQL Database with Source Code

Getting Started on How to Update Image in PHP with Demo in MySQL Database

This is a tutorial on How to Update Image in PHP with Demo in MySQL Database. In this tutorial, we are going to update the current Image to a new one. For this tutorial, we are going to use the UPDATE Statement to update the current image in our table. Let’s start with: This is the image that we are going to edit.

how to update image in php with demo

Updating Image

Modal Form Field

<div id="delete" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-header">
<h3 id="myModalLabel">Update</h3>
</div>
<div class="modal-body">
<div class="alert alert-danger">
<?php if($row['image_location'] != ""): ?>
<img src="uploads/" width="100px" height="100px" style="border:1px solid #333333; margin-left: 30px;">
<?php else: ?>
<img src="images/default.png" width="100px" height="100px" style="border:1px solid #333333; margin-left: 30px;">
<?php endif; ?>
<form action="edit_PDO.php" method="post" enctype="multipart/form-data">
<div style="color:blue; margin-left:150px; font-size:30px;">
<input type="file" name="image" style="margin-top:-115px;">
</div>
</div>
<hr>
<div class="modal-footer">
<button class="btn btn-inverse" data-dismiss="modal" aria-hidden="true">No</button>
<button type="submit" name="submit" class="btn btn-danger">Yes</button>
</form>
</div>
</div>
</div>

Creating Our Database

$conn = new PDO('mysql:host=localhost; dbname=upload_image','root', '');
?>

Creating Our UPDATE Statement

<?php
require_once ('db.php');
$get_id=$_REQUEST['tbl_image_id'];
move_uploaded_file($_FILES["image"]["tmp_name"],"uploads/" . $_FILES["image"]["name"]);
$location1=$_FILES["image"]["name"];
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "UPDATE tbl_image SET image_location ='$location1' WHERE tbl_image_id = '$get_id' ";
$conn->exec($sql);
echo " ";
?>

Output:

update image in php

Update The Current Image As you can see the current image was updated. How to Update Image in PHP with Demo in MySQL Database.

DEMO

Related Tutorials: Image Upload using Ajax in PHP, How to Upload an Image using AJAX in PHP and MySQLi, Change Image Name When Upload in PHP, How to Upload and Validate an Image File in PHP, Create Captcha Image in PHP, Image Upload Using PDO in PHP, Download Here

Tags

What's Your Reaction?

like

dislike

love

funny

angry

sad

wow